create table sys_post
(
    post_id     bigint identity
        constraint PK__sys_post__3ED787662432D3E0
            primary key,
    post_code   nvarchar(64) not null,
    post_name   nvarchar(50) not null,
    post_sort   int          not null,
    status      nchar        not null,
    create_by   nvarchar(64)
        constraint DF_sys_post_create_by default '',
    create_time datetime2(0),
    update_by   nvarchar(64)
        constraint DF_sys_post_update_by default '',
    update_time datetime2(0),
    remark      nvarchar(500)
)
go

exec sp_addextendedproperty 'MS_Description', '岗位信息表', 'SCHEMA', 'dbo', 'TABLE', 'sys_post'
go

exec sp_addextendedproperty 'MS_Description', '岗位ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'post_id'
go

exec sp_addextendedproperty 'MS_Description', '岗位编码', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'post_code'
go

exec sp_addextendedproperty 'MS_Description', '岗位名称', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'post_name'
go

exec sp_addextendedproperty 'MS_Description', '显示顺序', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'post_sort'
go

exec sp_addextendedproperty 'MS_Description', '状态（0正常 1停用）', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'status'
go

exec sp_addextendedproperty 'MS_Description', '创建者', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'create_by'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '更新者', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'update_by'
go

exec sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 'sys_post', 'COLUMN', 'remark'
go

INSERT INTO [ry-vue].dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) VALUES (1, N'ceo', N'董事长', 1, N'0', N'admin', N'2021-12-03 22:22:13', N'', null, N'');
INSERT INTO [ry-vue].dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) VALUES (2, N'se', N'项目经理', 2, N'0', N'admin', N'2021-12-03 22:22:13', N'', null, N'');
INSERT INTO [ry-vue].dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) VALUES (3, N'hr', N'人力资源', 3, N'0', N'admin', N'2021-12-03 22:22:13', N'', null, N'');
INSERT INTO [ry-vue].dbo.sys_post (post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark) VALUES (4, N'user', N'普通员工', 4, N'0', N'admin', N'2021-12-03 22:22:13', N'', null, N'');